﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="erpharmaDataSet" targetNamespace="http://tempuri.org/erpharmaDataSet.xsd" xmlns:mstns="http://tempuri.org/erpharmaDataSet.xsd" xmlns="http://tempuri.org/erpharmaDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="erpharmaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="erpharmaConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.IControl.My.MySettings.GlobalReference.Default.erpharmaConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dmkhachhangTableAdapter" GeneratorDataComponentClassName="dmkhachhangTableAdapter" Name="dmkhachhang" UserDataComponentName="dmkhachhangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.dmkhachhang" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[dmkhachhang] WHERE (([ma] = @Original_ma) AND ([ten] = @Original_ten) AND ((@IsNull_mataikhoan = 1 AND [mataikhoan] IS NULL) OR ([mataikhoan] = @Original_mataikhoan)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_maduong = 1 AND [maduong] IS NULL) OR ([maduong] = @Original_maduong)) AND ((@IsNull_maphuong = 1 AND [maphuong] IS NULL) OR ([maphuong] = @Original_maphuong)) AND ((@IsNull_maquan = 1 AND [maquan] IS NULL) OR ([maquan] = @Original_maquan)) AND ((@IsNull_phanloai = 1 AND [phanloai] IS NULL) OR ([phanloai] = @Original_phanloai)) AND ((@IsNull_loaikh = 1 AND [loaikh] IS NULL) OR ([loaikh] = @Original_loaikh)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_manhomkh = 1 AND [manhomkh] IS NULL) OR ([manhomkh] = @Original_manhomkh)) AND ((@IsNull_machinhanh = 1 AND [machinhanh] IS NULL) OR ([machinhanh] = @Original_machinhanh)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_tentat = 1 AND [tentat] IS NULL) OR ([tentat] = @Original_tentat)) AND ((@IsNull_matinh = 1 AND [matinh] IS NULL) OR ([matinh] = @Original_matinh)) AND ((@IsNull_tenkhuynhiemchi = 1 AND [tenkhuynhiemchi] IS NULL) OR ([tenkhuynhiemchi] = @Original_tenkhuynhiemchi)) AND ((@IsNull_daidien1 = 1 AND [daidien1] IS NULL) OR ([daidien1] = @Original_daidien1)) AND ((@IsNull_chucvu1 = 1 AND [chucvu1] IS NULL) OR ([chucvu1] = @Original_chucvu1)) AND ((@IsNull_dienthoai1 = 1 AND [dienthoai1] IS NULL) OR ([dienthoai1] = @Original_dienthoai1)) AND ((@IsNull_daidien2 = 1 AND [daidien2] IS NULL) OR ([daidien2] = @Original_daidien2)) AND ((@IsNull_chucvu2 = 1 AND [chucvu2] IS NULL) OR ([chucvu2] = @Original_chucvu2)) AND ((@IsNull_dienthoai2 = 1 AND [dienthoai2] IS NULL) OR ([dienthoai2] = @Original_dienthoai2)) AND ((@IsNull_maquocgia = 1 AND [maquocgia] IS NULL) OR ([maquocgia] = @Original_maquocgia)) AND ((@IsNull_makhuvuc = 1 AND [makhuvuc] IS NULL) OR ([makhuvuc] = @Original_makhuvuc)) AND ((@IsNull_makhcaptren = 1 AND [makhcaptren] IS NULL) OR ([makhcaptren] = @Original_makhcaptren)) AND ((@IsNull_hanmuctindung = 1 AND [hanmuctindung] IS NULL) OR ([hanmuctindung] = @Original_hanmuctindung)) AND ((@IsNull_hanthanhtoan = 1 AND [hanthanhtoan] IS NULL) OR ([hanthanhtoan] = @Original_hanthanhtoan)) AND ((@IsNull_loaihinhkd = 1 AND [loaihinhkd] IS NULL) OR ([loaihinhkd] = @Original_loaihinhkd)) AND ((@IsNull_ngayphatsinhgd = 1 AND [ngayphatsinhgd] IS NULL) OR ([ngayphatsinhgd] = @Original_ngayphatsinhgd)) AND ((@IsNull_ngaythanhlap = 1 AND [ngaythanhlap] IS NULL) OR ([ngaythanhlap] = @Original_ngaythanhlap)) AND ((@IsNull_nganhnghekd = 1 AND [nganhnghekd] IS NULL) OR ([nganhnghekd] = @Original_nganhnghekd)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_macu = 1 AND [macu] IS NULL) OR ([macu] = @Original_macu)) AND ((@IsNull_banggia = 1 AND [banggia] IS NULL) OR ([banggia] = @Original_banggia)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_giamgia = 1 AND [giamgia] IS NULL) OR ([giamgia] = @Original_giamgia)) AND ((@IsNull_diachigiaohang = 1 AND [diachigiaohang] IS NULL) OR ([diachigiaohang] = @Original_diachigiaohang)) AND ((@IsNull_loaivitri = 1 AND [loaivitri] IS NULL) OR ([loaivitri] = @Original_loaivitri)) AND ((@IsNull_loaietc = 1 AND [loaietc] IS NULL) OR ([loaietc] = @Original_loaietc)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mataikhoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mataikhoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maduong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maduong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maphuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maphuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maquan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phanloai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phanloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaikh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaikh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manhomkh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manhomkh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_machinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_machinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tentat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tentat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_matinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenkhuynhiemchi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenkhuynhiemchi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daidien1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_daidien1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chucvu1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chucvu1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daidien2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_daidien2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chucvu2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chucvu2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquocgia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maquocgia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhuvuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhuvuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhcaptren" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhcaptren" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hanmuctindung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_hanmuctindung" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihinhkd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihinhkd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayphatsinhgd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayphatsinhgd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaythanhlap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaythanhlap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nganhnghekd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nganhnghekd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_macu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_macu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_banggia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_chietkhau" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giamgia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_giamgia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachigiaohang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachigiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaivitri" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaivitri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaietc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaietc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[dmkhachhang] ([ma], [ten], [mataikhoan], [diachi], [maduong], [maphuong], [maquan], [phanloai], [loaikh], [ghichu], [manhomkh], [machinhanh], [dienthoai], [masothue], [tentat], [matinh], [tenkhuynhiemchi], [daidien1], [chucvu1], [dienthoai1], [daidien2], [chucvu2], [dienthoai2], [maquocgia], [makhuvuc], [makhcaptren], [hanmuctindung], [hanthanhtoan], [loaihinhkd], [ngayphatsinhgd], [ngaythanhlap], [nganhnghekd], [fax], [macu], [banggia], [chietkhau], [giamgia], [diachigiaohang], [loaivitri], [loaietc], [chinhanh], [tinhtrang]) VALUES (@ma, @ten, @mataikhoan, @diachi, @maduong, @maphuong, @maquan, @phanloai, @loaikh, @ghichu, @manhomkh, @machinhanh, @dienthoai, @masothue, @tentat, @matinh, @tenkhuynhiemchi, @daidien1, @chucvu1, @dienthoai1, @daidien2, @chucvu2, @dienthoai2, @maquocgia, @makhuvuc, @makhcaptren, @hanmuctindung, @hanthanhtoan, @loaihinhkd, @ngayphatsinhgd, @ngaythanhlap, @nganhnghekd, @fax, @macu, @banggia, @chietkhau, @giamgia, @diachigiaohang, @loaivitri, @loaietc, @chinhanh, @tinhtrang);
SELECT ma, ten, mataikhoan, diachi, maduong, maphuong, maquan, phanloai, loaikh, ghichu, manhomkh, machinhanh, dienthoai, masothue, tentat, matinh, tenkhuynhiemchi, daidien1, chucvu1, dienthoai1, daidien2, chucvu2, dienthoai2, maquocgia, makhuvuc, makhcaptren, hanmuctindung, hanthanhtoan, loaihinhkd, ngayphatsinhgd, ngaythanhlap, nganhnghekd, fax, macu, banggia, chietkhau, giamgia, diachigiaohang, loaivitri, loaietc, chinhanh, tinhtrang, id FROM dmkhachhang WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mataikhoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maduong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maphuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maquan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phanloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaikh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manhomkh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@machinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tentat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenkhuynhiemchi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@daidien1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chucvu1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@daidien2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chucvu2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maquocgia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhuvuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhcaptren" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@hanmuctindung" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihinhkd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayphatsinhgd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaythanhlap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nganhnghekd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@macu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@chietkhau" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@giamgia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachigiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaivitri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaietc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, mataikhoan, diachi, maduong, maphuong, maquan, phanloai, loaikh, ghichu, manhomkh, machinhanh, dienthoai, masothue, tentat, matinh, tenkhuynhiemchi, daidien1, chucvu1, dienthoai1, daidien2, chucvu2, dienthoai2, maquocgia, makhuvuc, makhcaptren, hanmuctindung, hanthanhtoan, loaihinhkd, ngayphatsinhgd, ngaythanhlap, nganhnghekd, fax, macu, banggia, chietkhau, giamgia, diachigiaohang, loaivitri, loaietc, chinhanh, tinhtrang, id FROM dbo.dmkhachhang</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[dmkhachhang] SET [ma] = @ma, [ten] = @ten, [mataikhoan] = @mataikhoan, [diachi] = @diachi, [maduong] = @maduong, [maphuong] = @maphuong, [maquan] = @maquan, [phanloai] = @phanloai, [loaikh] = @loaikh, [ghichu] = @ghichu, [manhomkh] = @manhomkh, [machinhanh] = @machinhanh, [dienthoai] = @dienthoai, [masothue] = @masothue, [tentat] = @tentat, [matinh] = @matinh, [tenkhuynhiemchi] = @tenkhuynhiemchi, [daidien1] = @daidien1, [chucvu1] = @chucvu1, [dienthoai1] = @dienthoai1, [daidien2] = @daidien2, [chucvu2] = @chucvu2, [dienthoai2] = @dienthoai2, [maquocgia] = @maquocgia, [makhuvuc] = @makhuvuc, [makhcaptren] = @makhcaptren, [hanmuctindung] = @hanmuctindung, [hanthanhtoan] = @hanthanhtoan, [loaihinhkd] = @loaihinhkd, [ngayphatsinhgd] = @ngayphatsinhgd, [ngaythanhlap] = @ngaythanhlap, [nganhnghekd] = @nganhnghekd, [fax] = @fax, [macu] = @macu, [banggia] = @banggia, [chietkhau] = @chietkhau, [giamgia] = @giamgia, [diachigiaohang] = @diachigiaohang, [loaivitri] = @loaivitri, [loaietc] = @loaietc, [chinhanh] = @chinhanh, [tinhtrang] = @tinhtrang WHERE (([ma] = @Original_ma) AND ([ten] = @Original_ten) AND ((@IsNull_mataikhoan = 1 AND [mataikhoan] IS NULL) OR ([mataikhoan] = @Original_mataikhoan)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_maduong = 1 AND [maduong] IS NULL) OR ([maduong] = @Original_maduong)) AND ((@IsNull_maphuong = 1 AND [maphuong] IS NULL) OR ([maphuong] = @Original_maphuong)) AND ((@IsNull_maquan = 1 AND [maquan] IS NULL) OR ([maquan] = @Original_maquan)) AND ((@IsNull_phanloai = 1 AND [phanloai] IS NULL) OR ([phanloai] = @Original_phanloai)) AND ((@IsNull_loaikh = 1 AND [loaikh] IS NULL) OR ([loaikh] = @Original_loaikh)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_manhomkh = 1 AND [manhomkh] IS NULL) OR ([manhomkh] = @Original_manhomkh)) AND ((@IsNull_machinhanh = 1 AND [machinhanh] IS NULL) OR ([machinhanh] = @Original_machinhanh)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_tentat = 1 AND [tentat] IS NULL) OR ([tentat] = @Original_tentat)) AND ((@IsNull_matinh = 1 AND [matinh] IS NULL) OR ([matinh] = @Original_matinh)) AND ((@IsNull_tenkhuynhiemchi = 1 AND [tenkhuynhiemchi] IS NULL) OR ([tenkhuynhiemchi] = @Original_tenkhuynhiemchi)) AND ((@IsNull_daidien1 = 1 AND [daidien1] IS NULL) OR ([daidien1] = @Original_daidien1)) AND ((@IsNull_chucvu1 = 1 AND [chucvu1] IS NULL) OR ([chucvu1] = @Original_chucvu1)) AND ((@IsNull_dienthoai1 = 1 AND [dienthoai1] IS NULL) OR ([dienthoai1] = @Original_dienthoai1)) AND ((@IsNull_daidien2 = 1 AND [daidien2] IS NULL) OR ([daidien2] = @Original_daidien2)) AND ((@IsNull_chucvu2 = 1 AND [chucvu2] IS NULL) OR ([chucvu2] = @Original_chucvu2)) AND ((@IsNull_dienthoai2 = 1 AND [dienthoai2] IS NULL) OR ([dienthoai2] = @Original_dienthoai2)) AND ((@IsNull_maquocgia = 1 AND [maquocgia] IS NULL) OR ([maquocgia] = @Original_maquocgia)) AND ((@IsNull_makhuvuc = 1 AND [makhuvuc] IS NULL) OR ([makhuvuc] = @Original_makhuvuc)) AND ((@IsNull_makhcaptren = 1 AND [makhcaptren] IS NULL) OR ([makhcaptren] = @Original_makhcaptren)) AND ((@IsNull_hanmuctindung = 1 AND [hanmuctindung] IS NULL) OR ([hanmuctindung] = @Original_hanmuctindung)) AND ((@IsNull_hanthanhtoan = 1 AND [hanthanhtoan] IS NULL) OR ([hanthanhtoan] = @Original_hanthanhtoan)) AND ((@IsNull_loaihinhkd = 1 AND [loaihinhkd] IS NULL) OR ([loaihinhkd] = @Original_loaihinhkd)) AND ((@IsNull_ngayphatsinhgd = 1 AND [ngayphatsinhgd] IS NULL) OR ([ngayphatsinhgd] = @Original_ngayphatsinhgd)) AND ((@IsNull_ngaythanhlap = 1 AND [ngaythanhlap] IS NULL) OR ([ngaythanhlap] = @Original_ngaythanhlap)) AND ((@IsNull_nganhnghekd = 1 AND [nganhnghekd] IS NULL) OR ([nganhnghekd] = @Original_nganhnghekd)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_macu = 1 AND [macu] IS NULL) OR ([macu] = @Original_macu)) AND ((@IsNull_banggia = 1 AND [banggia] IS NULL) OR ([banggia] = @Original_banggia)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_giamgia = 1 AND [giamgia] IS NULL) OR ([giamgia] = @Original_giamgia)) AND ((@IsNull_diachigiaohang = 1 AND [diachigiaohang] IS NULL) OR ([diachigiaohang] = @Original_diachigiaohang)) AND ((@IsNull_loaivitri = 1 AND [loaivitri] IS NULL) OR ([loaivitri] = @Original_loaivitri)) AND ((@IsNull_loaietc = 1 AND [loaietc] IS NULL) OR ([loaietc] = @Original_loaietc)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ([id] = @Original_id));
SELECT ma, ten, mataikhoan, diachi, maduong, maphuong, maquan, phanloai, loaikh, ghichu, manhomkh, machinhanh, dienthoai, masothue, tentat, matinh, tenkhuynhiemchi, daidien1, chucvu1, dienthoai1, daidien2, chucvu2, dienthoai2, maquocgia, makhuvuc, makhcaptren, hanmuctindung, hanthanhtoan, loaihinhkd, ngayphatsinhgd, ngaythanhlap, nganhnghekd, fax, macu, banggia, chietkhau, giamgia, diachigiaohang, loaivitri, loaietc, chinhanh, tinhtrang, id FROM dmkhachhang WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mataikhoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maduong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maphuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maquan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phanloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaikh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manhomkh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@machinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tentat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenkhuynhiemchi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@daidien1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chucvu1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@daidien2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chucvu2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maquocgia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhuvuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makhcaptren" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@hanmuctindung" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihinhkd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayphatsinhgd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaythanhlap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nganhnghekd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@macu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@chietkhau" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@giamgia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachigiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaivitri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaietc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mataikhoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mataikhoan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mataikhoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maduong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maduong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maduong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maphuong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maphuong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphuong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maquan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_phanloai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_phanloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phanloai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaikh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaikh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaikh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manhomkh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manhomkh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhomkh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_machinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_machinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tentat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tentat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_matinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_matinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="matinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenkhuynhiemchi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenkhuynhiemchi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenkhuynhiemchi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daidien1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_daidien1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chucvu1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chucvu1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_daidien2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_daidien2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="daidien2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chucvu2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chucvu2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chucvu2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maquocgia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maquocgia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maquocgia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhuvuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhuvuc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhuvuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_makhcaptren" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_makhcaptren" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makhcaptren" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hanmuctindung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_hanmuctindung" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="hanmuctindung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_hanthanhtoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hanthanhtoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihinhkd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihinhkd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihinhkd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayphatsinhgd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayphatsinhgd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayphatsinhgd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaythanhlap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaythanhlap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhlap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nganhnghekd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nganhnghekd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhnghekd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_macu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_macu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="macu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_banggia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_banggia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="banggia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_chietkhau" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giamgia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_giamgia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giamgia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachigiaohang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachigiaohang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachigiaohang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaivitri" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaivitri" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaivitri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaietc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaietc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaietc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.dmkhachhang" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="mataikhoan" DataSetColumn="mataikhoan" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="maduong" DataSetColumn="maduong" />
              <Mapping SourceColumn="maphuong" DataSetColumn="maphuong" />
              <Mapping SourceColumn="maquan" DataSetColumn="maquan" />
              <Mapping SourceColumn="phanloai" DataSetColumn="phanloai" />
              <Mapping SourceColumn="loaikh" DataSetColumn="loaikh" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="manhomkh" DataSetColumn="manhomkh" />
              <Mapping SourceColumn="machinhanh" DataSetColumn="machinhanh" />
              <Mapping SourceColumn="dienthoai" DataSetColumn="dienthoai" />
              <Mapping SourceColumn="masothue" DataSetColumn="masothue" />
              <Mapping SourceColumn="tentat" DataSetColumn="tentat" />
              <Mapping SourceColumn="matinh" DataSetColumn="matinh" />
              <Mapping SourceColumn="tenkhuynhiemchi" DataSetColumn="tenkhuynhiemchi" />
              <Mapping SourceColumn="daidien1" DataSetColumn="daidien1" />
              <Mapping SourceColumn="chucvu1" DataSetColumn="chucvu1" />
              <Mapping SourceColumn="dienthoai1" DataSetColumn="dienthoai1" />
              <Mapping SourceColumn="daidien2" DataSetColumn="daidien2" />
              <Mapping SourceColumn="chucvu2" DataSetColumn="chucvu2" />
              <Mapping SourceColumn="dienthoai2" DataSetColumn="dienthoai2" />
              <Mapping SourceColumn="maquocgia" DataSetColumn="maquocgia" />
              <Mapping SourceColumn="makhuvuc" DataSetColumn="makhuvuc" />
              <Mapping SourceColumn="makhcaptren" DataSetColumn="makhcaptren" />
              <Mapping SourceColumn="hanmuctindung" DataSetColumn="hanmuctindung" />
              <Mapping SourceColumn="hanthanhtoan" DataSetColumn="hanthanhtoan" />
              <Mapping SourceColumn="loaihinhkd" DataSetColumn="loaihinhkd" />
              <Mapping SourceColumn="ngayphatsinhgd" DataSetColumn="ngayphatsinhgd" />
              <Mapping SourceColumn="ngaythanhlap" DataSetColumn="ngaythanhlap" />
              <Mapping SourceColumn="nganhnghekd" DataSetColumn="nganhnghekd" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="macu" DataSetColumn="macu" />
              <Mapping SourceColumn="banggia" DataSetColumn="banggia" />
              <Mapping SourceColumn="chietkhau" DataSetColumn="chietkhau" />
              <Mapping SourceColumn="giamgia" DataSetColumn="giamgia" />
              <Mapping SourceColumn="diachigiaohang" DataSetColumn="diachigiaohang" />
              <Mapping SourceColumn="loaivitri" DataSetColumn="loaivitri" />
              <Mapping SourceColumn="loaietc" DataSetColumn="loaietc" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="conTableAdapter" GeneratorDataComponentClassName="conTableAdapter" Name="con" UserDataComponentName="conTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.con" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[con] WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_gia = 1 AND [gia] IS NULL) OR ([gia] = @Original_gia)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[con] ([ma], [ten], [ngay], [gia]) VALUES (@ma, @ten, @ngay, @gia);
SELECT ma, ten, ngay, gia, id FROM con WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, ngay, gia, id FROM dbo.con</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[con] SET [ma] = @ma, [ten] = @ten, [ngay] = @ngay, [gia] = @gia WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_gia = 1 AND [gia] IS NULL) OR ([gia] = @Original_gia)) AND ([id] = @Original_id));
SELECT ma, ten, ngay, gia, id FROM con WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.con" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ngay" DataSetColumn="ngay" />
              <Mapping SourceColumn="gia" DataSetColumn="gia" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="chaTableAdapter" GeneratorDataComponentClassName="chaTableAdapter" Name="cha" UserDataComponentName="chaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.cha" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[cha] WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_gia = 1 AND [gia] IS NULL) OR ([gia] = @Original_gia)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[cha] ([ma], [ten], [ngay], [gia]) VALUES (@ma, @ten, @ngay, @gia);
SELECT ma, ten, ngay, gia, id FROM cha WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, ngay, gia, id FROM dbo.cha</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[cha] SET [ma] = @ma, [ten] = @ten, [ngay] = @ngay, [gia] = @gia WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_gia = 1 AND [gia] IS NULL) OR ([gia] = @Original_gia)) AND ([id] = @Original_id));
SELECT ma, ten, ngay, gia, id FROM cha WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.cha" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ngay" DataSetColumn="ngay" />
              <Mapping SourceColumn="gia" DataSetColumn="gia" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="con_copyTableAdapter" GeneratorDataComponentClassName="con_copyTableAdapter" Name="con_copy" UserDataComponentName="con_copyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="erpharmaConnectionString (MySettings)" DbObjectName="erpharma.dbo.con_copy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [con_copy] WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ([id] = @Original_id) AND ((@IsNull_gia_1 = 1 AND [gia_1] IS NULL) OR ([gia_1] = @Original_gia_1)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gia_1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gia_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_gia_1" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [con_copy] ([ma], [ten], [ngay], [gia_1]) VALUES (@ma, @ten, @ngay, @gia_1);
SELECT ma, ten, ngay, id, gia_1 FROM con_copy WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@gia_1" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, ngay, id, gia_1 FROM con_copy</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [con_copy] SET [ma] = @ma, [ten] = @ten, [ngay] = @ngay, [gia_1] = @gia_1 WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ([id] = @Original_id) AND ((@IsNull_gia_1 = 1 AND [gia_1] IS NULL) OR ([gia_1] = @Original_gia_1)));
SELECT ma, ten, ngay, id, gia_1 FROM con_copy WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@gia_1" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gia_1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gia_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_gia_1" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="erpharma.dbo.con_copy" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ngay" DataSetColumn="ngay" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="gia_1" DataSetColumn="gia_1" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="erpharmaDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="erpharmaDataSet" msprop:Generator_UserDSName="erpharmaDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dmkhachhang" msprop:Generator_TableClassName="dmkhachhangDataTable" msprop:Generator_TableVarName="tabledmkhachhang" msprop:Generator_TablePropName="dmkhachhang" msprop:Generator_RowDeletingName="dmkhachhangRowDeleting" msprop:Generator_RowChangingName="dmkhachhangRowChanging" msprop:Generator_RowEvHandlerName="dmkhachhangRowChangeEventHandler" msprop:Generator_RowDeletedName="dmkhachhangRowDeleted" msprop:Generator_UserTableName="dmkhachhang" msprop:Generator_RowChangedName="dmkhachhangRowChanged" msprop:Generator_RowEvArgName="dmkhachhangRowChangeEvent" msprop:Generator_RowClassName="dmkhachhangRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mataikhoan" msprop:Generator_ColumnVarNameInTable="columnmataikhoan" msprop:Generator_ColumnPropNameInRow="mataikhoan" msprop:Generator_ColumnPropNameInTable="mataikhoanColumn" msprop:Generator_UserColumnName="mataikhoan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maduong" msprop:Generator_ColumnVarNameInTable="columnmaduong" msprop:Generator_ColumnPropNameInRow="maduong" msprop:Generator_ColumnPropNameInTable="maduongColumn" msprop:Generator_UserColumnName="maduong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maphuong" msprop:Generator_ColumnVarNameInTable="columnmaphuong" msprop:Generator_ColumnPropNameInRow="maphuong" msprop:Generator_ColumnPropNameInTable="maphuongColumn" msprop:Generator_UserColumnName="maphuong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maquan" msprop:Generator_ColumnVarNameInTable="columnmaquan" msprop:Generator_ColumnPropNameInRow="maquan" msprop:Generator_ColumnPropNameInTable="maquanColumn" msprop:Generator_UserColumnName="maquan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phanloai" msprop:Generator_ColumnVarNameInTable="columnphanloai" msprop:Generator_ColumnPropNameInRow="phanloai" msprop:Generator_ColumnPropNameInTable="phanloaiColumn" msprop:Generator_UserColumnName="phanloai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaikh" msprop:Generator_ColumnVarNameInTable="columnloaikh" msprop:Generator_ColumnPropNameInRow="loaikh" msprop:Generator_ColumnPropNameInTable="loaikhColumn" msprop:Generator_UserColumnName="loaikh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manhomkh" msprop:Generator_ColumnVarNameInTable="columnmanhomkh" msprop:Generator_ColumnPropNameInRow="manhomkh" msprop:Generator_ColumnPropNameInTable="manhomkhColumn" msprop:Generator_UserColumnName="manhomkh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machinhanh" msprop:Generator_ColumnVarNameInTable="columnmachinhanh" msprop:Generator_ColumnPropNameInRow="machinhanh" msprop:Generator_ColumnPropNameInTable="machinhanhColumn" msprop:Generator_UserColumnName="machinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai" msprop:Generator_ColumnVarNameInTable="columndienthoai" msprop:Generator_ColumnPropNameInRow="dienthoai" msprop:Generator_ColumnPropNameInTable="dienthoaiColumn" msprop:Generator_UserColumnName="dienthoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masothue" msprop:Generator_ColumnVarNameInTable="columnmasothue" msprop:Generator_ColumnPropNameInRow="masothue" msprop:Generator_ColumnPropNameInTable="masothueColumn" msprop:Generator_UserColumnName="masothue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tentat" msprop:Generator_ColumnVarNameInTable="columntentat" msprop:Generator_ColumnPropNameInRow="tentat" msprop:Generator_ColumnPropNameInTable="tentatColumn" msprop:Generator_UserColumnName="tentat" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="matinh" msprop:Generator_ColumnVarNameInTable="columnmatinh" msprop:Generator_ColumnPropNameInRow="matinh" msprop:Generator_ColumnPropNameInTable="matinhColumn" msprop:Generator_UserColumnName="matinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenkhuynhiemchi" msprop:Generator_ColumnVarNameInTable="columntenkhuynhiemchi" msprop:Generator_ColumnPropNameInRow="tenkhuynhiemchi" msprop:Generator_ColumnPropNameInTable="tenkhuynhiemchiColumn" msprop:Generator_UserColumnName="tenkhuynhiemchi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="daidien1" msprop:Generator_ColumnVarNameInTable="columndaidien1" msprop:Generator_ColumnPropNameInRow="daidien1" msprop:Generator_ColumnPropNameInTable="daidien1Column" msprop:Generator_UserColumnName="daidien1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chucvu1" msprop:Generator_ColumnVarNameInTable="columnchucvu1" msprop:Generator_ColumnPropNameInRow="chucvu1" msprop:Generator_ColumnPropNameInTable="chucvu1Column" msprop:Generator_UserColumnName="chucvu1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai1" msprop:Generator_ColumnVarNameInTable="columndienthoai1" msprop:Generator_ColumnPropNameInRow="dienthoai1" msprop:Generator_ColumnPropNameInTable="dienthoai1Column" msprop:Generator_UserColumnName="dienthoai1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="daidien2" msprop:Generator_ColumnVarNameInTable="columndaidien2" msprop:Generator_ColumnPropNameInRow="daidien2" msprop:Generator_ColumnPropNameInTable="daidien2Column" msprop:Generator_UserColumnName="daidien2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chucvu2" msprop:Generator_ColumnVarNameInTable="columnchucvu2" msprop:Generator_ColumnPropNameInRow="chucvu2" msprop:Generator_ColumnPropNameInTable="chucvu2Column" msprop:Generator_UserColumnName="chucvu2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai2" msprop:Generator_ColumnVarNameInTable="columndienthoai2" msprop:Generator_ColumnPropNameInRow="dienthoai2" msprop:Generator_ColumnPropNameInTable="dienthoai2Column" msprop:Generator_UserColumnName="dienthoai2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maquocgia" msprop:Generator_ColumnVarNameInTable="columnmaquocgia" msprop:Generator_ColumnPropNameInRow="maquocgia" msprop:Generator_ColumnPropNameInTable="maquocgiaColumn" msprop:Generator_UserColumnName="maquocgia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="makhuvuc" msprop:Generator_ColumnVarNameInTable="columnmakhuvuc" msprop:Generator_ColumnPropNameInRow="makhuvuc" msprop:Generator_ColumnPropNameInTable="makhuvucColumn" msprop:Generator_UserColumnName="makhuvuc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="makhcaptren" msprop:Generator_ColumnVarNameInTable="columnmakhcaptren" msprop:Generator_ColumnPropNameInRow="makhcaptren" msprop:Generator_ColumnPropNameInTable="makhcaptrenColumn" msprop:Generator_UserColumnName="makhcaptren" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hanmuctindung" msprop:Generator_ColumnVarNameInTable="columnhanmuctindung" msprop:Generator_ColumnPropNameInRow="hanmuctindung" msprop:Generator_ColumnPropNameInTable="hanmuctindungColumn" msprop:Generator_UserColumnName="hanmuctindung" type="xs:decimal" minOccurs="0" />
              <xs:element name="hanthanhtoan" msprop:Generator_ColumnVarNameInTable="columnhanthanhtoan" msprop:Generator_ColumnPropNameInRow="hanthanhtoan" msprop:Generator_ColumnPropNameInTable="hanthanhtoanColumn" msprop:Generator_UserColumnName="hanthanhtoan" type="xs:int" minOccurs="0" />
              <xs:element name="loaihinhkd" msprop:Generator_ColumnVarNameInTable="columnloaihinhkd" msprop:Generator_ColumnPropNameInRow="loaihinhkd" msprop:Generator_ColumnPropNameInTable="loaihinhkdColumn" msprop:Generator_UserColumnName="loaihinhkd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayphatsinhgd" msprop:Generator_ColumnVarNameInTable="columnngayphatsinhgd" msprop:Generator_ColumnPropNameInRow="ngayphatsinhgd" msprop:Generator_ColumnPropNameInTable="ngayphatsinhgdColumn" msprop:Generator_UserColumnName="ngayphatsinhgd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ngaythanhlap" msprop:Generator_ColumnVarNameInTable="columnngaythanhlap" msprop:Generator_ColumnPropNameInRow="ngaythanhlap" msprop:Generator_ColumnPropNameInTable="ngaythanhlapColumn" msprop:Generator_UserColumnName="ngaythanhlap" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nganhnghekd" msprop:Generator_ColumnVarNameInTable="columnnganhnghekd" msprop:Generator_ColumnPropNameInRow="nganhnghekd" msprop:Generator_ColumnPropNameInTable="nganhnghekdColumn" msprop:Generator_UserColumnName="nganhnghekd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnPropNameInTable="faxColumn" msprop:Generator_UserColumnName="fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="macu" msprop:Generator_ColumnVarNameInTable="columnmacu" msprop:Generator_ColumnPropNameInRow="macu" msprop:Generator_ColumnPropNameInTable="macuColumn" msprop:Generator_UserColumnName="macu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="banggia" msprop:Generator_ColumnVarNameInTable="columnbanggia" msprop:Generator_ColumnPropNameInRow="banggia" msprop:Generator_ColumnPropNameInTable="banggiaColumn" msprop:Generator_UserColumnName="banggia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chietkhau" msprop:Generator_ColumnVarNameInTable="columnchietkhau" msprop:Generator_ColumnPropNameInRow="chietkhau" msprop:Generator_ColumnPropNameInTable="chietkhauColumn" msprop:Generator_UserColumnName="chietkhau" type="xs:decimal" minOccurs="0" />
              <xs:element name="giamgia" msprop:Generator_ColumnVarNameInTable="columngiamgia" msprop:Generator_ColumnPropNameInRow="giamgia" msprop:Generator_ColumnPropNameInTable="giamgiaColumn" msprop:Generator_UserColumnName="giamgia" type="xs:decimal" minOccurs="0" />
              <xs:element name="diachigiaohang" msprop:Generator_ColumnVarNameInTable="columndiachigiaohang" msprop:Generator_ColumnPropNameInRow="diachigiaohang" msprop:Generator_ColumnPropNameInTable="diachigiaohangColumn" msprop:Generator_UserColumnName="diachigiaohang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaivitri" msprop:Generator_ColumnVarNameInTable="columnloaivitri" msprop:Generator_ColumnPropNameInRow="loaivitri" msprop:Generator_ColumnPropNameInTable="loaivitriColumn" msprop:Generator_UserColumnName="loaivitri" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaietc" msprop:Generator_ColumnVarNameInTable="columnloaietc" msprop:Generator_ColumnPropNameInRow="loaietc" msprop:Generator_ColumnPropNameInTable="loaietcColumn" msprop:Generator_UserColumnName="loaietc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="con" msprop:Generator_TableClassName="conDataTable" msprop:Generator_TableVarName="tablecon" msprop:Generator_RowChangedName="conRowChanged" msprop:Generator_TablePropName="con" msprop:Generator_RowDeletingName="conRowDeleting" msprop:Generator_RowChangingName="conRowChanging" msprop:Generator_RowEvHandlerName="conRowChangeEventHandler" msprop:Generator_RowDeletedName="conRowDeleted" msprop:Generator_RowClassName="conRow" msprop:Generator_UserTableName="con" msprop:Generator_RowEvArgName="conRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngay" msprop:Generator_ColumnVarNameInTable="columnngay" msprop:Generator_ColumnPropNameInRow="ngay" msprop:Generator_ColumnPropNameInTable="ngayColumn" msprop:Generator_UserColumnName="ngay" type="xs:dateTime" minOccurs="0" />
              <xs:element name="gia" msprop:Generator_ColumnVarNameInTable="columngia" msprop:Generator_ColumnPropNameInRow="gia" msprop:Generator_ColumnPropNameInTable="giaColumn" msprop:Generator_UserColumnName="gia" type="xs:decimal" minOccurs="0" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="cha" msprop:Generator_TableClassName="chaDataTable" msprop:Generator_TableVarName="tablecha" msprop:Generator_TablePropName="cha" msprop:Generator_RowDeletingName="chaRowDeleting" msprop:Generator_RowChangingName="chaRowChanging" msprop:Generator_RowEvHandlerName="chaRowChangeEventHandler" msprop:Generator_RowDeletedName="chaRowDeleted" msprop:Generator_UserTableName="cha" msprop:Generator_RowChangedName="chaRowChanged" msprop:Generator_RowEvArgName="chaRowChangeEvent" msprop:Generator_RowClassName="chaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngay" msprop:Generator_ColumnVarNameInTable="columnngay" msprop:Generator_ColumnPropNameInRow="ngay" msprop:Generator_ColumnPropNameInTable="ngayColumn" msprop:Generator_UserColumnName="ngay" type="xs:dateTime" minOccurs="0" />
              <xs:element name="gia" msprop:Generator_ColumnVarNameInTable="columngia" msprop:Generator_ColumnPropNameInRow="gia" msprop:Generator_ColumnPropNameInTable="giaColumn" msprop:Generator_UserColumnName="gia" type="xs:decimal" minOccurs="0" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="con_copy" msprop:Generator_TableClassName="con_copyDataTable" msprop:Generator_TableVarName="tablecon_copy" msprop:Generator_TablePropName="con_copy" msprop:Generator_RowDeletingName="con_copyRowDeleting" msprop:Generator_RowChangingName="con_copyRowChanging" msprop:Generator_RowEvHandlerName="con_copyRowChangeEventHandler" msprop:Generator_RowDeletedName="con_copyRowDeleted" msprop:Generator_UserTableName="con_copy" msprop:Generator_RowChangedName="con_copyRowChanged" msprop:Generator_RowEvArgName="con_copyRowChangeEvent" msprop:Generator_RowClassName="con_copyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngay" msprop:Generator_ColumnVarNameInTable="columnngay" msprop:Generator_ColumnPropNameInRow="ngay" msprop:Generator_ColumnPropNameInTable="ngayColumn" msprop:Generator_UserColumnName="ngay" type="xs:dateTime" minOccurs="0" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
              <xs:element name="gia_1" msprop:Generator_ColumnVarNameInTable="columngia_1" msprop:Generator_ColumnPropNameInRow="gia_1" msprop:Generator_ColumnPropNameInTable="gia_1Column" msprop:Generator_UserColumnName="gia_1" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dmkhachhang" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="con_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:con" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="cha_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:cha" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Constraint2">
      <xs:selector xpath=".//mstns:cha" />
      <xs:field xpath="mstns:ma" />
    </xs:unique>
    <xs:unique name="con_copy_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:con_copy" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:keyref name="FK_con_cha" refer="Constraint2" msprop:rel_Generator_UserChildTable="con" msprop:rel_Generator_ChildPropName="GetconRows" msprop:rel_Generator_UserRelationName="FK_con_cha" msprop:rel_Generator_ParentPropName="chaRow" msprop:rel_Generator_RelationVarName="relationFK_con_cha" msprop:rel_Generator_UserParentTable="cha">
      <xs:selector xpath=".//mstns:con" />
      <xs:field xpath="mstns:ma" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK__con_copy__ma__2858E14B" msdata:parent="cha" msdata:child="con_copy" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="con_copy" msprop:Generator_ChildPropName="Getcon_copyRows" msprop:Generator_UserRelationName="FK__con_copy__ma__2858E14B" msprop:Generator_ParentPropName="chaRow" msprop:Generator_RelationVarName="relationFK__con_copy__ma__2858E14B" msprop:Generator_UserParentTable="cha" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>